﻿  IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'tb_Vendor_Distribution_TopsXPole') 
AND name = N'IDX_tb_Vendor_Distribution_TopsXPole_Vendor_Distribution_PoleFk')
	DROP INDEX IDX_tb_Vendor_Distribution_TopsXPole_Vendor_Distribution_PoleFk ON tb_Vendor_Distribution_TopsXPole WITH ( ONLINE = OFF )

CREATE NONCLUSTERED INDEX IDX_tb_Vendor_Distribution_TopsXPole_Vendor_Distribution_PoleFk ON tb_Vendor_Distribution_TopsXPole
(
	Vendor_Distribution_PoleFk
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
